//定义当前应用的版本
#define APP_VERSION 1

//宣传页的版本
#define SPLASH_VERSION 1

//宣传页的张数
#define PAGE_NUMS 3

@interface Constants : NSObject {
    NSArray *createTableCmdArray;
}
@end


@implementation Constants
- (instancetype)init
{
    self = [super init];
    if (self) {
        createTableCmdArray = [[NSArray alloc]initWithObjects:
                               @"create table if not exists SPLASH_VERSION (version integer PRIMARY KEY)",
                               
                               //=============教师，园长端的数据表=============
                               /*
                               @"create table if not exists myinfo (id integer, name char, hasLogin integer, level integer, username char, phone char, schoolid integer, avatar char, status integer, whichClass integer, confirm integer, schoolname char, schoolcode char, access_token char, token_exp_time char, refresh_token char, mycoursetype integer)",
                               //myclassinfo
                               @"create table if not exists myclassinfo(id integer, schoolid integer, name char, stunum integer, grade integer, code char, userid integer)",
                               //classmembers
                               @"create table if not exists classmembers(classid integer, childid integer, childname char, childavatar char, parentname char, parentphone char)",
                               //version
                               @"create table if not exists version(localVersionCode integer)",
                               //dynamictable
                               @"create table if not exists dynamictable(id INTEGER PRIMARY KEY AUTOINCREMENT, userid integer, type integer, schoolid integer, classid integer, title char, time char, content char, authorid integer, name char, avatar char, pics char)",
                               //totalhomework
                               @"create table if not exists totalhomework(bnum integer, bid integer, preurl char, bookname char, pid integer, title char, descp char, fc_id integer, sc_id integer, scene char)",
                               //usualhomework
                               @"create table if not exists usualhomework(userid integer, bnum integer, bid integer)",
                               //===========================================
                               */
                               
                               //========================家长端数据表=================
                               @"create table if not exists nbg_home_my_info (id integer PRIMARY KEY, nickname char, hasLogin integer, utype integer, username char, phone char,  avatar char, status integer, access_token char, token_exp_time char, refresh_token char, fid integer, frole integer, fcode char)",
                               @"create table if not exists nbg_home_baby_info(pid integer,cid integer PRIMARY KEY,cname char,cavatar char,birthy integer,birthm integer,birthd integer,fid integer,sex integer,classid integer,classname char,schoolid integer,schoolname char,kx_auth integer, focusid integer)",
                               @"create table if not exists nbg_home_dongtai(fromid integer,fromname char,fromhead char,content text,date datetime,currentuserid integer,photo char,id integer PRIMARY KEY,type integer)",
                               @"create table if not exists nbg_home_homework(date char,title char,content text,icon char,type char,id integer PRIMARY KEY,currentuserid integer,pid integer)",
                               @"create table if not exists nbg_home_message(replyid integer,replyname char,replyhead char,content text,myreply text,postid integer,currentuserid integer,id integer PRIMARY KEY)",
                               @"create table if not exists nbg_home_notification(schoolid integer,classid integer,title char,content text,fromid integer,fromname char,fromhead char,date datetime,type integer,currentuserid integer,id integer PRIMARY KEY)",
                               @"create table if not exists nbg_home_parent_info(uid integer PRIMARY KEY,nickname char,avatar char,account char,fid integer,frole integer,utype integer,haslogin integer,focuschildid integer)",
                               @"create table if not exists nbg_home_post(postid integer PRIMARY KEY,posterid integer,posterhead char,postername char,title char,date datetime,replycount integer,hottype integer,currentuserid integer)",
                               @"create table if not exists nbg_version(version integer)",
                               
                               nil];
    }
    return self;
}

- (NSArray *)getCreateTableCmdArray{
    return createTableCmdArray;
    
}



@end
